﻿-- =============================================
-- Script Template
-- =============================================
SET IDENTITY_INSERT [ODCore].[ResponsibleParty] ON
INSERT [ODCore].[ResponsibleParty] ([SourceID], [SourceGroup], [SourceCode], [SourceName], [SourceDescription], [SourceRole], [ContactName], [ContactEmail], [ContactPhone]) VALUES (0, 0, N'DBAdmin', N'Vijay Dantuluri', N'Database Administrator', N'Curator', N'Vijay Dantuluri', N'vijayd@renci.org', N'919-445-9639')
SET IDENTITY_INSERT [ODCore].[ResponsibleParty] OFF

SET IDENTITY_INSERT [ODCore].[Method] ON
INSERT [ODCore].[Method] ([MethodID], [MethodName], [MethodDescription]) VALUES (1, N'Not Specified', N'Method information not provided')
INSERT [ODCore].[Method] ([MethodID], [MethodName], [MethodDescription]) VALUES (2, N'Winkler Method', N'Sodium thiosulfate titration of water sample')
INSERT [ODCore].[Method] ([MethodID], [MethodName], [MethodDescription]) VALUES (3, N'Salicylate Method', N'Colorimetric method that uses blue indophenol reaction between ammonia, salicylate and hypochlorite at high pH')
INSERT [ODCore].[Method] ([MethodID], [MethodName], [MethodDescription]) VALUES (4, N'USEPA, 2006, Method 1106.1', N'Enterococci in water by membrane filtration using membrane-Enterococcus-Esculin Iron Agar (mE-EIA)')
INSERT [ODCore].[Method] ([MethodID], [MethodName], [MethodDescription]) VALUES (5, N'Simpson''s empirical formula', N'Empirical equation for converting wind velocity to wind force in Beaufort scale by G. C. Simpson (1906)')
INSERT [ODCore].[Method] ([MethodID], [MethodName], [MethodDescription]) VALUES (6, N'Doppler Radar product', N'Mesoscale vorticity method (MVM) is used in conjunction with the ground-based velocity track display to derive the inner-core vertical velocity from Doppler radar observations')
INSERT [ODCore].[Method] ([MethodID], [MethodName], [MethodDescription]) VALUES (7, N'Derived - lookup', N'Categorical values derived from numeric values using a lookup table')
INSERT [ODCore].[Method] ([MethodID], [MethodName], [MethodDescription]) VALUES (8, N'Lugol’s iodine', N'Samples fixed with 2% Lugol''s Iodine solution')
SET IDENTITY_INSERT [ODCore].[Method] OFF

SET IDENTITY_INSERT [ODCore].[ControlledVocabulary] ON
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (0, N'Unspecified', N'To be used when a category is present but not applicable')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (1, N'Dam', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (2, N'Standard Units', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (3, N'Length', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (4, N'Volume', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (5, N'Area', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (6, N'Time', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (7, N'Sensor', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (8, N'Aquifer', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (10, N'Water', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (11, N'Sample', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (13, N'Instantaneous', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (14, N'Density', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (15, N'DateTime', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (16, N'Passed', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (17, N'Failed', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (18, N'Field Observation', N'ObservationType')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (19, N'Temperature', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (20, N'Air', N'Used for air quality and meteorologic observations including wind, precipitation, radiation')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (21, N'Flux', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (22, N'Continuous', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (23, N'Incremental', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (24, N'Mean', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (25, N'Maximum', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (26, N'Minimum', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (28, N'Moving Average', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (29, N'Date', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (30, N'Velocity', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (31, N'Current Density', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (32, N'WS', N'Water Surface')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (33, N'MSL', N'Mean Sea Level')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (34, N'LS', N'Land Surface')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (35, N'SS', N'Snow Surface')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (36, N'SE', N'Sensor Elevation')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (37, N'NGVD29', N'National Geodetic Vertical Datum of 1929')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (38, N'NAVD88', N'North American Vertical Datum of 1988')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (39, N'CGVD28', N'Canadian Geodetic Vertical Datum of 1928')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (40, N'Angle', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (41, N'Pressure', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (42, N'Remote Sensing', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (43, N'Derived', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (44, N'Currency', NULL)
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (45, N'Feature Geometry', N'Observation value doesn''t vary across the geometry')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (46, N'Trajectory', N'Trajectory of a moving vessel represented as a linestring')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (47, N'Grid', N'Gridded data for rasters')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (48, N'Profile/Graph', N'Data in X-Y-Value triples. For example rating curves, cross sections, or lake temperature profiles')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (49, N'nc', N'not censored')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (50, N'lt', N'less than')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (51, N'gt', N'greater than')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (52, N'bdt', N'present but below detection limit')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (53, N'Grab', N'Grab sample')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (54, N'Composite', N'Mixture of multiple grab samples')
SET IDENTITY_INSERT [ODCore].[ControlledVocabulary] OFF

SET IDENTITY_INSERT [ODCore].[DataQuality] ON
INSERT [ODCore].[DataQuality] ([DataQualityID], [Description], [QCRating], [QCResultID], [ResponsiblePartyID], [DateCreated]) VALUES (1, N'Unknown', 0, 0, 0, CAST(0x00009A7100000000 AS DateTime))
INSERT [ODCore].[DataQuality] ([DataQualityID], [Description], [QCRating], [QCResultID], [ResponsiblePartyID], [DateCreated]) VALUES (2, N'Data quality information not provided', 0, 0, 0, CAST(0x00009A7100000000 AS DateTime))
INSERT [ODCore].[DataQuality] ([DataQualityID], [Description], [QCRating], [QCResultID], [ResponsiblePartyID], [DateCreated]) VALUES (3, N'Passed quality assessment tests', 1, 16, 0, CAST(0x00009AF200000000 AS DateTime))
SET IDENTITY_INSERT [ODCore].[DataQuality] OFF

SET IDENTITY_INSERT [ODCore].[Unit]  ON
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (1, 2, N'N/A', N'not applicable')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (2, 3, N'ft', N'international foot')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (3, 4, N'ac-ft', N'acre feet')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (4, 5, N'ac', N'acre')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (5, 5, N'mi^2', N'square mile')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (6, 6, N'yyyy', N'4 digit year')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (7, 14, N'colonies/100ml', N'colonies per 100 milliliters')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (8, 19, N'°C', N'degrees Celsius')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (9, 6, N'd', N'day')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (10, 6, N'min', N'minute')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (11, 6, N'h', N'hour')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (12, 14, N'mg/l', N'milligrams per liter')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (13, 21, N'W/m2', N'watts per square meter')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (14, 30, N'm/s', N'meters per second')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (15, 31, N'W/m-2 mV-1', N'watts per square meter per millivolt')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (16, 2, N'-', N'dimensionless')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (17, 2, N'%', N'percent')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (18, 3, N'µm', N'micrometer')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (19, 40, N'°', N'degrees Azimuth (clockwise from North)')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (20, 41, N'mbar', N'millibar')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (21, 30, N'kt', N'knot')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (22, 44, N'$', N'US Dollars')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (23, 4, N'l', N'liter')
INSERT [ODCore].[Unit]  ([UnitID], [UnitTypeID], [UnitAbbreviation], [UnitDescription]) VALUES (24, 3, N'mm', N'millimeter')
SET IDENTITY_INSERT [ODCore].[Unit]  OFF

INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (0, N'All')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (1, N'ODCore.Feature.FeatureTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (2, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (3, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (4, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (5, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (6, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (7, N'ODCore.Feature.FeatureTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (8, N'ODCore.Feature.FeatureTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (46, N'ODCore.Feature.FeatureTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (10, N'ODCore.ObservedVariable.ObservationMediumID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (11, N'ODCore.SeriesCatalog.ObservationTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (53, N'ODData.Sample.SampleTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (13, N'ODCore.TimeSupport.DataTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (14, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (15, N'ODCore.TimeSupport.ReportingPrecisionID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (16, N'ODCore.DataQuality.QCResultID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (17, N'ODCore.DataQuality.QCResultID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (18, N'ODCore.SeriesCatalog.ObservationTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (19, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (20, N'ODCore.ObservedVariable.ObservationMediumID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (21, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (22, N'ODCore.TimeSupport.DataTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (23, N'ODCore.TimeSupport.DataTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (24, N'ODCore.TimeSupport.DataTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (25, N'ODCore.TimeSupport.DataTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (26, N'ODCore.TimeSupport.DataTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (28, N'ODCore.TimeSupport.DataTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (29, N'ODCore.TimeSupport.ReportingPrecisionID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (30, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (31, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (32, N'ODData.Observation.VerticalReferenceID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (33, N'ODData.Observation.VerticalReferenceID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (34, N'ODData.Observation.VerticalReferenceID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (35, N'ODData.Observation.VerticalReferenceID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (36, N'ODData.Observation.VerticalReferenceID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (37, N'ODData.Observation.VerticalReferenceID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (38, N'ODData.Observation.VerticalReferenceID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (39, N'ODData.Observation.VerticalReferenceID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (40, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (41, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (42, N'ODCore.SeriesCatalog.ObservationTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (43, N'ODCore.SeriesCatalog.ObservationTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (49, N'ODData.Observation.CensorID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (50, N'ODData.Observation.CensorID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (51, N'ODData.Observation.CensorID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (52, N'ODData.Observation.CensorID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (45, N'ODCore.SeriesCatalog.SpatialRepresentationTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (46, N'ODCore.SeriesCatalog.SpatialRepresentationTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (47, N'ODCore.SeriesCatalog.SpatialRepresentationTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (48, N'ODCore.SeriesCatalog.SpatialRepresentationTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (44, N'ODCore.Unit.UnitTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (54, N'ODData.Sample.SampleTypeID')

--Added as part of State Climatology Office Cronos ECONET integration
SET IDENTITY_INSERT [ODCore].[ControlledVocabulary] ON
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (129, N'battmin', N'Battery voltage')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (130, N'c1sm', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (131, N'c1tmp', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (132, N'c2sm', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (133, N'c2tmp', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (134, N'c3sm', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (135, N'c3tmp', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (136, N'c4sm', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (137, N'c4tmp', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (138, N'c5sm', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (139, N'c5tmp', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (140, N'diravgwind', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (141, N'diravgwind02', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (142, N'evap', N'Evapotranspiration')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (143, N'gust', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (144, N'gust02', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (145, N'gust06', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (146, N'gustavg', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (147, N'gustdir', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (148, N'gustmax', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (149, N'gustmax02', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (150, N'gustmaxdir', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (151, N'gustmaxdir02', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (152, N'gustmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (153, N'gustmaxtime02', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (154, N'par', N'Radiation, net PAR')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (155, N'paravg', N'Radiation, net PAR')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (156, N'parmax', N'Radiation, net PAR')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (157, N'parmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (158, N'precip', N'Precipitation')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (159, N'pres', N'Barometric pressure')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (160, N'presavg', N'Barometric pressure')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (161, N'presmax', N'Barometric pressure')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (162, N'presmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (163, N'presmin', N'Barometric pressure')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (164, N'presmintime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (165, N'rh', N'Relative humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (166, N'rh10', N'Relative humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (167, N'rhavg', N'Relative humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (168, N'rhavg10', N'Relative humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (169, N'rhmax', N'Relative humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (170, N'rhmax10', N'Relative humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (171, N'rhmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (172, N'rhmaxtime10', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (173, N'rhmin', N'Relative humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (174, N'rhmin10', N'Relative humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (175, N'rhmintime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (176, N'rhmintime10', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (177, N'sm', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (178, N'smavg', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (179, N'smmax', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (180, N'smmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (181, N'smmin', N'Volumetric water content')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (182, N'smmintime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (183, N'speedavgwind', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (184, N'speedavgwind02', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (185, N'sr', N'Radiation, net')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (186, N'sravg', N'Radiation, net')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (187, N'srmax', N'Radiation, net')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (188, N'srmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (189, N'st', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (190, N'stavg', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (191, N'stmax', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (192, N'stmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (193, N'stmin', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (194, N'stmintime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (195, N'temp', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (196, N'temp10', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (197, N'tempavg', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (198, N'tempavg10', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (199, N'tempmax', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (200, N'tempmax10', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (201, N'tempmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (202, N'tempmaxtime10', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (203, N'tempmin', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (204, N'tempmin10', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (205, N'tempmintime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (206, N'tempmintime10', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (207, N'wd', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (208, N'wd02', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (209, N'wd06', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (210, N'wdavg', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (211, N'wdavg02', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (212, N'wdmax', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (213, N'wdmax02', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (214, N'winddiravg', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (215, N'windsd', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (216, N'windsd02', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (217, N'ws', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (218, N'ws02', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (219, N'ws06', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (220, N'wsavg', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (221, N'wsavg02', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (222, N'wsmax', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (223, N'wsmax02', N'Wind speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (224, N'wsmaxdir', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (225, N'wsmaxdir02', N'Wind direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (226, N'wsmaxtime', N'Time')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (227, N'wsmaxtime02', N'Time')
SET IDENTITY_INSERT [ODCore].[ControlledVocabulary] OFF

INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (129, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (130, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (131, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (132, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (133, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (134, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (135, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (136, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (137, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (138, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (139, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (140, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (141, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (142, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (143, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (144, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (145, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (146, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (147, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (148, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (149, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (150, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (151, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (152, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (153, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (154, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (155, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (156, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (157, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (158, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (159, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (160, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (161, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (162, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (163, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (164, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (165, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (166, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (167, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (168, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (169, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (170, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (171, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (172, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (173, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (174, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (175, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (176, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (177, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (178, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (179, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (180, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (181, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (182, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (183, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (184, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (185, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (186, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (187, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (188, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (189, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (190, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (191, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (192, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (193, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (194, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (195, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (196, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (197, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (198, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (199, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (200, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (201, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (202, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (203, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (204, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (205, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (206, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (207, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (208, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (209, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (210, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (211, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (212, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (213, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (214, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (215, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (216, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (217, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (218, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (219, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (220, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (221, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (222, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (223, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (224, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (225, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (226, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (227, N'ODCore.ObservedVariable.VariableCodeID')

--Added as part of RENCI Brunswick County Flood Sensors integration
SET IDENTITY_INSERT [ODCore].[ControlledVocabulary] ON
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (228, N'BaseStation', N'Feature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (229, N'air_pressure', N'Barometric Pressure')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (230, N'air_temp', N'Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (231, N'hail_acc', N'Hail Accumulation')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (232, N'hail_duration', N'Hail Duration')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (233, N'hail_intensity', N'Hail Intensity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (234, N'hail_peak_intensity', N'Hail Peak Intensity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (235, N'heating_temp', N'Heating Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (236, N'heating_voltage', N'Heating Voltage')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (237, N'qual', N'Measurement Quality')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (238, N'rain_acc', N'Rain Accumulation')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (239, N'rain_duration', N'Rain Duration')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (240, N'rain_intensity', N'Rain Intensity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (241, N'rain_peak_intensity', N'Rain Peak Intensity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (242, N'ref_voltage', N'Reference Voltage')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (243, N'rel_humidity', N'Relative Humidity')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (244, N'spot_voltage', N'Battery Voltage')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (245, N'supply_voltage', N'Supply Voltage')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (246, N'water_dist', N'Water level')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (247, N'water_lev', N'Water level')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (248, N'water_temp', N'Water Temperature')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (249, N'winddir_avg', N'Wind Direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (250, N'winddir_max', N'Wind Direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (251, N'winddir_min', N'Wind Direction')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (252, N'windspeed_avg', N'Wind Speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (253, N'windspeed_max', N'Wind Speed')
INSERT [ODCore].[ControlledVocabulary] ([TermID], [Term], [TermDefinition]) VALUES (254, N'windspeed_min', N'Wind Speed')
SET IDENTITY_INSERT [ODCore].[ControlledVocabulary] OFF

INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (228, N'ODCore.Feature.FeatureTypeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (229, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (230, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (231, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (232, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (233, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (234, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (235, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (236, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (237, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (238, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (239, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (240, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (241, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (242, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (243, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (244, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (245, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (246, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (247, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (248, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (249, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (250, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (251, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (252, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (253, N'ODCore.ObservedVariable.VariableCodeID')
INSERT [ODCore].[TermTableMapping] ([TermID], [AttributeReference]) VALUES (254, N'ODCore.ObservedVariable.VariableCodeID')


